/*
 Navicat Premium Dump SQL

 Source Server         : cz
 Source Server Type    : SQL Server
 Source Server Version : 13001601 (13.00.1601)
 Source Host           : liukang.vip:60008
 Source Catalog        : weighing
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 13001601 (13.00.1601)
 File Encoding         : 65001

 Date: 04/11/2025 13:30:22
*/


-- ----------------------------
-- Table structure for comMaterialGroup
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[comMaterialGroup]') AND type IN ('U'))
	DROP TABLE [dbo].[comMaterialGroup]
GO

CREATE TABLE [dbo].[comMaterialGroup] (
  [MaterialId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [MaterialName] nvarchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [MaterialSpec] nvarchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [MaterialType] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [UnitId] nvarchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [EnableFlag] bit DEFAULT 1 NULL,
  [CreateDate] datetime DEFAULT getdate() NULL
)
GO

ALTER TABLE [dbo].[comMaterialGroup] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'物料编号',
'SCHEMA', N'dbo',
'TABLE', N'comMaterialGroup',
'COLUMN', N'MaterialId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'物料名称',
'SCHEMA', N'dbo',
'TABLE', N'comMaterialGroup',
'COLUMN', N'MaterialName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'物料规格',
'SCHEMA', N'dbo',
'TABLE', N'comMaterialGroup',
'COLUMN', N'MaterialSpec'
GO

EXEC sp_addextendedproperty
'MS_Description', N'物料类型',
'SCHEMA', N'dbo',
'TABLE', N'comMaterialGroup',
'COLUMN', N'MaterialType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单位',
'SCHEMA', N'dbo',
'TABLE', N'comMaterialGroup',
'COLUMN', N'UnitId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'启用标志（1=启用，0=停用）',
'SCHEMA', N'dbo',
'TABLE', N'comMaterialGroup',
'COLUMN', N'EnableFlag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建日期',
'SCHEMA', N'dbo',
'TABLE', N'comMaterialGroup',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'物料信息表',
'SCHEMA', N'dbo',
'TABLE', N'comMaterialGroup'
GO


-- ----------------------------
-- Records of comMaterialGroup
-- ----------------------------
INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPH0A01-N018', N'软铜', N'0.018', NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPH0EC01-018C', N'电解铜', N'0.018', NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPH0KA01-A010', N'纳米铜', N'0.105', NULL, N'M2', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHF1R01-030D', N'防溢胶带XPH标识导电布', N'0.03', NULL, N'M2', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHGS02', N'丙烯酸树脂', NULL, NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHGS04', N'丙烯酸树脂', NULL, NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHGV04', N'丙烯酸树脂', NULL, NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHJ-G01S', N'固化剂', NULL, NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHJ-G01V', N'固化剂', NULL, NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHK0251K', N'PI膜', N'0.025', NULL, N'M2', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHL050P-10M', N'单硅离型膜', N'0.05', NULL, N'M2', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHL050Q-1010Y', N'双硅离型膜', N'0.05', NULL, N'M2', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHL115X-0535H', N'XPH双硅离型纸', N'0.115', NULL, N'M2', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHM0501-050', N'透明PET', N'0.05', NULL, N'M2', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHM1501-006T', N'黑色PET', N'0.006', NULL, N'M2', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHP-C50L0', N'导电粉', N'500目', NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHP-C60L0', N'导电粉', N'600目', NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO

INSERT INTO [dbo].[comMaterialGroup] ([MaterialId], [MaterialName], [MaterialSpec], [MaterialType], [UnitId], [EnableFlag], [CreateDate]) VALUES (N'XPHX-E01V', N'稀释剂', NULL, NULL, N'KG', N'1', N'2025-11-04 13:28:23.793')
GO


-- ----------------------------
-- Table structure for CU_CUZLLSub
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[CU_CUZLLSub]') AND type IN ('U'))
	DROP TABLE [dbo].[CU_CUZLLSub]
GO

CREATE TABLE [dbo].[CU_CUZLLSub] (
  [BillNo] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [RowNo] int DEFAULT 0 NOT NULL,
  [RowCode] int DEFAULT 0 NOT NULL,
  [FromSourceTag] int DEFAULT 0 NOT NULL,
  [FromTransId] bigint DEFAULT 0 NOT NULL,
  [FromBillNo] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [FromRowCode] int DEFAULT 0 NOT NULL,
  [CU_MaterialId] varchar(40) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [CU_quantity] numeric(19,9) DEFAULT 0 NULL,
  [CU_kuan] numeric(19,9) DEFAULT 0 NOT NULL,
  [CU_chang] numeric(19,9) DEFAULT 0 NOT NULL,
  [CU_juan] numeric(19,9) DEFAULT 0 NOT NULL,
  [CU_bl] numeric(19,9) DEFAULT 0 NOT NULL,
  [CU_batchNo] nvarchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [CU_czTime] bigint DEFAULT 0 NULL,
  [CU_isWeighing] bit DEFAULT 0 NULL,
  [CU_isMainMaterial] bit DEFAULT 0 NULL,
  [CU_RemainTakeQty] numeric(19,9) DEFAULT 0 NULL,
  [CU_TotalQuantity] numeric(19,9) DEFAULT 0 NULL,
  [CU_xlTime] bigint DEFAULT 0 NULL
)
GO

ALTER TABLE [dbo].[CU_CUZLLSub] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'单据编号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'BillNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'序号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'RowNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标识号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'RowCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'来源单种类',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'FromSourceTag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'流程配置编号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'FromTransId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'来源单号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'FromBillNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'来源标识号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'FromRowCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'物料代码',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_MaterialId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'本次称重量',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_quantity'
GO

EXEC sp_addextendedproperty
'MS_Description', N'宽',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_kuan'
GO

EXEC sp_addextendedproperty
'MS_Description', N'长',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_chang'
GO

EXEC sp_addextendedproperty
'MS_Description', N'卷',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_juan'
GO

EXEC sp_addextendedproperty
'MS_Description', N'比例',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_bl'
GO

EXEC sp_addextendedproperty
'MS_Description', N'批号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_batchNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'称重时间',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_czTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否称重',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_isWeighing'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否主胶',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_isMainMaterial'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产允领量',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_RemainTakeQty'
GO

EXEC sp_addextendedproperty
'MS_Description', N'累计称重量',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_TotalQuantity'
GO

EXEC sp_addextendedproperty
'MS_Description', N'下料时间',
'SCHEMA', N'dbo',
'TABLE', N'CU_CUZLLSub',
'COLUMN', N'CU_xlTime'
GO


-- ----------------------------
-- Records of CU_CUZLLSub
-- ----------------------------

-- ----------------------------
-- Table structure for CU_CZLLMain
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[CU_CZLLMain]') AND type IN ('U'))
	DROP TABLE [dbo].[CU_CZLLMain]
GO

CREATE TABLE [dbo].[CU_CZLLMain] (
  [CreatorId] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [CreateTime] bigint DEFAULT 0 NOT NULL,
  [LastOperatorId] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [LastOperateTime] bigint DEFAULT 0 NOT NULL,
  [Remark] nvarchar(2000) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [AttachementCount] smallint DEFAULT 0 NOT NULL,
  [InternalId] bigint DEFAULT 0 NOT NULL,
  [HasPostil] bit DEFAULT 0 NOT NULL,
  [TimesPrinted] smallint DEFAULT 0 NOT NULL,
  [TimesEmailSend] smallint DEFAULT 0 NOT NULL,
  [TimesExported] smallint DEFAULT 0 NOT NULL,
  [PermitterId] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [PermitTime] bigint DEFAULT 0 NOT NULL,
  [PermitState] tinyint DEFAULT 0 NOT NULL,
  [FlowState] tinyint DEFAULT 0 NOT NULL,
  [VaryState] tinyint DEFAULT 0 NOT NULL,
  [MergeOutState] tinyint DEFAULT 0 NOT NULL,
  [IsInUsed] bit DEFAULT 0 NOT NULL,
  [AuthorizedId] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [BillNo] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [BillDate] int DEFAULT 0 NOT NULL,
  [TypeId] varchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [CurrentState] tinyint DEFAULT 0 NOT NULL,
  [EndOperatorId] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [EndTime] bigint DEFAULT 0 NOT NULL,
  [FOrgId] varchar(40) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [CompId] varchar(15) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [FromSourceTag] int DEFAULT 0 NOT NULL,
  [FromTransId] bigint DEFAULT 0 NOT NULL,
  [FromBillNo] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [CU_PersonId] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [CU_DeptId] varchar(15) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL
)
GO

ALTER TABLE [dbo].[CU_CZLLMain] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'CreatorId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后修改人',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'LastOperatorId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后修改时间',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'LastOperateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'附件',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'AttachementCount'
GO

EXEC sp_addextendedproperty
'MS_Description', N'内部标识号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'InternalId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'批注',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'HasPostil'
GO

EXEC sp_addextendedproperty
'MS_Description', N'打印次数',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'TimesPrinted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Email次数',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'TimesEmailSend'
GO

EXEC sp_addextendedproperty
'MS_Description', N'输出次数',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'TimesExported'
GO

EXEC sp_addextendedproperty
'MS_Description', N'核准人',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'PermitterId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'核准时间',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'PermitTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'审核状态',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'PermitState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'流程状态',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'FlowState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'变更状态',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'VaryState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'抛转状态',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'MergeOutState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'被用状态',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'IsInUsed'
GO

EXEC sp_addextendedproperty
'MS_Description', N'信息权限组',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'AuthorizedId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单据编号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'BillNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单据日期',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'BillDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单据类型 005 称重单，006下料单',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'TypeId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'CurrentState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'结案人',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'EndOperatorId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'结案时间',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'EndTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'核算组织',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'FOrgId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'公司',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'CompId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'来源单种类',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'FromSourceTag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'流程配置编号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'FromTransId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'来源单号',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'FromBillNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申请人员',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'CU_PersonId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申请部门',
'SCHEMA', N'dbo',
'TABLE', N'CU_CZLLMain',
'COLUMN', N'CU_DeptId'
GO


-- ----------------------------
-- Records of CU_CZLLMain
-- ----------------------------

-- ----------------------------
-- Table structure for ppProduceOrder
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[ppProduceOrder]') AND type IN ('U'))
	DROP TABLE [dbo].[ppProduceOrder]
GO

CREATE TABLE [dbo].[ppProduceOrder] (
  [BillNo] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [BillDate] datetime  NULL,
  [MaterialId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [MaterialSpec] nvarchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [ProduceState] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [ProduceQty] decimal(18,4)  NULL,
  [CurrentState] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [CreateDate] datetime DEFAULT getdate() NULL,
  [CreateBy] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [UpdateDate] datetime  NULL,
  [UpdateBy] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[ppProduceOrder] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'工单号',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'BillNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工单日期',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'BillDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'母件编号',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'MaterialId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'母件规格',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'MaterialSpec'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产状态',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'ProduceState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产数量',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'ProduceQty'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工单状态',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'CurrentState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建日期',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'CreateBy'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新日期',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'UpdateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新人',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder',
'COLUMN', N'UpdateBy'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产工单主表',
'SCHEMA', N'dbo',
'TABLE', N'ppProduceOrder'
GO


-- ----------------------------
-- Records of ppProduceOrder
-- ----------------------------
INSERT INTO [dbo].[ppProduceOrder] ([BillNo], [BillDate], [MaterialId], [MaterialSpec], [ProduceState], [ProduceQty], [CurrentState], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy]) VALUES (N'1', N'2021-01-06 00:00:00.000', N'XPH0KA02-CA050T_P', N'0.16', N'4', N'76.0000', N'4', N'2025-11-04 13:28:02.320', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[ppProduceOrder] ([BillNo], [BillDate], [MaterialId], [MaterialSpec], [ProduceState], [ProduceQty], [CurrentState], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy]) VALUES (N'2', N'2021-01-06 00:00:00.000', N'XPHM05P4-200_PP', N'0.2', N'2', N'1918.3500', N'4', N'2025-11-04 13:28:02.320', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[ppProduceOrder] ([BillNo], [BillDate], [MaterialId], [MaterialSpec], [ProduceState], [ProduceQty], [CurrentState], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy]) VALUES (N'4', N'2021-01-06 00:00:00.000', N'XPH0EC02-1812_P', N'0.03', N'4', N'2550.0000', N'4', N'2025-11-04 13:28:02.320', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[ppProduceOrder] ([BillNo], [BillDate], [MaterialId], [MaterialSpec], [ProduceState], [ProduceQty], [CurrentState], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy]) VALUES (N'5', N'2021-01-06 00:00:00.000', N'XPHM1504-5006T_PP', N'0.05', N'2', N'980.0000', N'4', N'2025-11-04 13:28:02.320', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[ppProduceOrder] ([BillNo], [BillDate], [MaterialId], [MaterialSpec], [ProduceState], [ProduceQty], [CurrentState], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy]) VALUES (N'6', N'2021-01-06 00:00:00.000', N'XPHF1R03-050D_P', N'0.05', N'2', N'1070.0000', N'4', N'2025-11-04 13:28:02.320', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[ppProduceOrder] ([BillNo], [BillDate], [MaterialId], [MaterialSpec], [ProduceState], [ProduceQty], [CurrentState], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy]) VALUES (N'7', N'2021-01-06 00:00:00.000', N'XPH0A03-N1835_P', N'0.05', N'4', N'51.0000', N'4', N'2025-11-04 13:28:02.320', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[ppProduceOrder] ([BillNo], [BillDate], [MaterialId], [MaterialSpec], [ProduceState], [ProduceQty], [CurrentState], [CreateDate], [CreateBy], [UpdateDate], [UpdateBy]) VALUES (N'8', N'2021-01-06 00:00:00.000', N'XPHK0T12-2525S_P', N'0.05', N'4', N'1500.0000', N'4', N'2025-11-04 13:28:02.320', NULL, NULL, NULL)
GO


-- ----------------------------
-- Table structure for ppSubMaterialInfo
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[ppSubMaterialInfo]') AND type IN ('U'))
	DROP TABLE [dbo].[ppSubMaterialInfo]
GO

CREATE TABLE [dbo].[ppSubMaterialInfo] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [BillNo] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [RowCode] int  NULL,
  [SubMaterialId] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [SubMaterialSpec] nvarchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [UnitId] nvarchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [ProduceNeedQty] decimal(18,4)  NULL,
  [RemainTakeQty] decimal(18,4)  NULL,
  [CU_sczldzjkuan] decimal(18,4)  NULL,
  [CU_sczldzjchang] decimal(18,4)  NULL,
  [CU_sczldzjjuan] decimal(18,4)  NULL,
  [cu_sfcz] bit  NULL,
  [CU_isMainMaterial] bit  NULL,
  [CU_Interval] int  NULL
)
GO

ALTER TABLE [dbo].[ppSubMaterialInfo] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'工单号',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'BillNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'行号',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'RowCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'子件编号',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'SubMaterialId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'子件规格',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'SubMaterialSpec'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单位',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'UnitId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产应用量',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'ProduceNeedQty'
GO

EXEC sp_addextendedproperty
'MS_Description', N'未领数量',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'RemainTakeQty'
GO

EXEC sp_addextendedproperty
'MS_Description', N'宽',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'CU_sczldzjkuan'
GO

EXEC sp_addextendedproperty
'MS_Description', N'长',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'CU_sczldzjchang'
GO

EXEC sp_addextendedproperty
'MS_Description', N'卷',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'CU_sczldzjjuan'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否称重（1=是，0=否）',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'cu_sfcz'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否主胶（1=是，0=否）',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'CU_isMainMaterial'
GO

EXEC sp_addextendedproperty
'MS_Description', N'下料间隔时间（分钟）',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo',
'COLUMN', N'CU_Interval'
GO

EXEC sp_addextendedproperty
'MS_Description', N'生产子件信息表',
'SCHEMA', N'dbo',
'TABLE', N'ppSubMaterialInfo'
GO


-- ----------------------------
-- Records of ppSubMaterialInfo
-- ----------------------------
SET IDENTITY_INSERT [dbo].[ppSubMaterialInfo] ON
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'1', N'1', N'1', N'XPH0KA01-A010', N'0.105', N'M2', N'76.0000', N'-19.3800', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'2', N'1', N'2', N'XPHL115X-0535H', N'0.115', N'M2', N'98.8000', N'-63.2000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'3', N'1', N'3', N'XPHGV04', NULL, N'KG', N'9.1200', N'-10.8800', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'4', N'1', N'4', N'XPHJ-G01V', NULL, N'KG', N'0.1370', N'-0.1630', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'5', N'1', N'5', N'XPHX-E01V', NULL, N'KG', N'0.9120', N'-1.0880', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'6', N'2', N'1', N'XPHM0501-050', N'0.05', N'M2', N'1918.3500', N'525.8500', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'7', N'2', N'2', N'XPHL050Q-1010Y', N'0.05', N'M2', N'2493.8550', N'803.3550', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'8', N'2', N'4', N'XPHGS04', NULL, N'KG', N'613.8720', N'133.7720', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'9', N'2', N'5', N'XPHJ-G01S', NULL, N'KG', N'9.8220', N'2.1370', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'10', N'2', N'6', N'XPHL050P-10M', N'0.05', N'M2', N'2493.8550', N'858.8550', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'11', N'4', N'1', N'XPH0EC01-018C', N'0.018', N'KG', N'408.0000', N'-29.0000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'12', N'4', N'3', N'XPHGV04', NULL, N'KG', N'76.5000', N'-24.8000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'13', N'4', N'4', N'XPHJ-G01V', NULL, N'KG', N'1.1480', N'-0.3750', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'14', N'4', N'5', N'XPHX-E01V', NULL, N'KG', N'61.2000', N'-19.9000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'15', N'4', N'6', N'XPHL050P-10M', N'0.05', N'M2', N'3315.0000', N'126.7500', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'16', N'5', N'1', N'XPHM1501-006T', N'0.006', N'M2', N'980.0000', N'-47.5000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'17', N'5', N'3', N'XPHGS04', NULL, N'KG', N'98.0000', N'-15.2000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'18', N'5', N'4', N'XPHJ-G01S', NULL, N'KG', N'0.9800', N'-0.1540', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'19', N'5', N'5', N'XPHX-E01V', NULL, N'KG', N'49.0000', N'-7.7000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'20', N'5', N'6', N'XPHL050P-10M', N'0.05', N'M2', N'2548.0000', N'177.2500', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'21', N'6', N'1', N'XPHF1R01-030D', N'0.03', N'M2', N'1070.0000', N'50.8500', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'22', N'6', N'2', N'XPHL050Q-1010Y', N'0.05', N'M2', N'1391.0000', N'224.7000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'23', N'6', N'3', N'XPHGS04', NULL, N'KG', N'64.2000', N'4.2000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'24', N'6', N'4', N'XPHJ-G01S', NULL, N'KG', N'0.8990', N'0.0580', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'25', N'6', N'5', N'XPHX-E01V', NULL, N'KG', N'32.1000', N'2.1000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'26', N'6', N'6', N'XPHP-C60L0', N'600目', N'KG', N'1.9260', N'0.1260', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'27', N'7', N'1', N'XPH0A01-N018', N'0.018', N'KG', N'8.6700', N'-3.3300', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'28', N'7', N'3', N'XPHGV04', NULL, N'KG', N'4.0800', N'-7.1200', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'29', N'7', N'4', N'XPHJ-G01V', NULL, N'KG', N'0.0610', N'-0.1070', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'30', N'7', N'5', N'XPHX-E01V', NULL, N'KG', N'1.2240', N'-2.1760', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'31', N'7', N'6', N'XPHP-C50L0', N'500目', N'KG', N'0.1220', N'-0.2140', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'32', N'7', N'7', N'XPHL050P-10M', N'0.05', N'M2', N'66.3000', N'66.3000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'33', N'8', N'1', N'XPHK0251K', N'0.025', N'M2', N'1500.0000', N'-1337.2800', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'34', N'8', N'3', N'XPHGS02', NULL, N'KG', N'105.0000', N'-119.9000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'35', N'8', N'4', N'XPHJ-G01S', NULL, N'KG', N'0.3150', N'-0.3600', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'36', N'8', N'5', N'XPHX-E01V', NULL, N'KG', N'31.5000', N'-36.0000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

INSERT INTO [dbo].[ppSubMaterialInfo] ([Id], [BillNo], [RowCode], [SubMaterialId], [SubMaterialSpec], [UnitId], [ProduceNeedQty], [RemainTakeQty], [CU_sczldzjkuan], [CU_sczldzjchang], [CU_sczldzjjuan], [cu_sfcz], [CU_isMainMaterial], [CU_Interval]) VALUES (N'37', N'8', N'6', N'XPHL050P-10M', N'0.05', N'M2', N'1950.0000', N'-1320.0000', N'0.0000', N'0.0000', N'0.0000', N'0', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[ppSubMaterialInfo] OFF
GO


-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_config]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_config]
GO

CREATE TABLE [dbo].[sys_config] (
  [config_id] int  IDENTITY(1,1) NOT NULL,
  [config_name] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [config_key] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [config_value] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [config_type] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT 'N' NULL,
  [create_by] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime DEFAULT getdate() NULL,
  [update_by] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime  NULL,
  [remark] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_config] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_config
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_config] ON
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'主框架页-默认皮肤样式名称', N'sys.index.skinName', N'skin-blue', N'Y', N'admin', N'2025-11-03 10:44:54.610', N'', NULL, N'蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'用户管理-账号初始密码', N'sys.user.initPassword', N'123456', N'Y', N'admin', N'2025-11-03 10:44:54.610', N'', NULL, N'初始化密码 123456')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'主框架页-侧边栏主题', N'sys.index.sideTheme', N'theme-dark', N'Y', N'admin', N'2025-11-03 10:44:54.610', N'', NULL, N'深色主题theme-dark，浅色主题theme-light')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'账号自助-验证码开关', N'sys.account.captchaEnabled', N'true', N'Y', N'admin', N'2025-11-03 10:44:54.610', N'', NULL, N'是否开启验证码功能（true开启，false关闭）')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'5', N'账号自助-是否开启用户注册功能', N'sys.account.registerUser', N'false', N'Y', N'admin', N'2025-11-03 10:44:54.610', N'', NULL, N'是否开启注册用户功能（true开启，false关闭）')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'6', N'用户登录-黑名单列表', N'sys.login.blackIPList', N'', N'Y', N'admin', N'2025-11-03 10:44:54.610', N'', NULL, N'设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'7', N'用户管理-初始密码修改策略', N'sys.account.initPasswordModify', N'1', N'Y', N'admin', N'2025-11-03 10:44:54.610', N'', NULL, N'0：关闭策略，1：提醒用户修改初始密码')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'8', N'用户管理-账号密码更新周期', N'sys.account.passwordValidateDays', N'0', N'Y', N'admin', N'2025-11-03 10:44:54.610', N'', NULL, N'密码更新周期（0为不限制）')
GO

SET IDENTITY_INSERT [dbo].[sys_config] OFF
GO


-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dept]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dept]
GO

CREATE TABLE [dbo].[sys_dept] (
  [dept_id] bigint  IDENTITY(1,1) NOT NULL,
  [parent_id] bigint DEFAULT 0 NULL,
  [ancestors] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [dept_name] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [order_num] int DEFAULT 0 NULL,
  [leader] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [phone] varchar(11) COLLATE Chinese_PRC_CI_AS  NULL,
  [email] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [status] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [del_flag] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [create_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [create_time] datetime  NULL,
  [update_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [update_time] datetime  NULL
)
GO

ALTER TABLE [dbo].[sys_dept] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_dept
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_dept] ON
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'100', N'0', N'0', N'若依科技a', N'0', N'若依a', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'admin', N'2025-11-03 11:29:44.293')
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'101', N'100', N'0,100', N'深圳总公司', N'1', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'102', N'100', N'0,100', N'长沙分公司', N'2', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'103', N'101', N'0,100,101', N'研发部门', N'1', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'104', N'101', N'0,100,101', N'市场部门', N'2', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'105', N'101', N'0,100,101', N'测试部门', N'3', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'106', N'101', N'0,100,101', N'财务部门', N'4', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'107', N'101', N'0,100,101', N'运维部门', N'5', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'108', N'102', N'0,100,102', N'市场部门', N'1', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'109', N'102', N'0,100,102', N'财务部门', N'2', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2025-11-03 10:31:54.487', N'', NULL)
GO

SET IDENTITY_INSERT [dbo].[sys_dept] OFF
GO


-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dict_data]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dict_data]
GO

CREATE TABLE [dbo].[sys_dict_data] (
  [dict_code] bigint  IDENTITY(100,1) NOT NULL,
  [dict_sort] int DEFAULT 0 NULL,
  [dict_label] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [dict_value] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [dict_type] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [css_class] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [list_class] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [is_default] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT 'N' NULL,
  [status] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [create_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [create_time] datetime  NULL,
  [update_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [update_time] datetime  NULL,
  [remark] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_dict_data] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_dict_data] ON
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'1', N'男', N'0', N'sys_user_sex', N'', N'', N'Y', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'性别男')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'2', N'女', N'1', N'sys_user_sex', N'', N'', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'性别女')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'3', N'未知', N'2', N'sys_user_sex', N'', N'', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'性别未知')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'1', N'显示', N'0', N'sys_show_hide', N'', N'primary', N'Y', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'显示菜单')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'5', N'2', N'隐藏', N'1', N'sys_show_hide', N'', N'danger', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'隐藏菜单')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'6', N'1', N'正常', N'0', N'sys_normal_disable', N'', N'primary', N'Y', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'正常状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'7', N'2', N'停用', N'1', N'sys_normal_disable', N'', N'danger', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'停用状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'8', N'1', N'正常', N'0', N'sys_job_status', N'', N'primary', N'Y', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'正常状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'9', N'2', N'暂停', N'1', N'sys_job_status', N'', N'danger', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'停用状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'10', N'1', N'默认', N'DEFAULT', N'sys_job_group', N'', N'', N'Y', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'默认分组')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'11', N'2', N'系统', N'SYSTEM', N'sys_job_group', N'', N'', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'系统分组')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'12', N'1', N'是', N'Y', N'sys_yes_no', N'', N'primary', N'Y', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'系统默认是')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'13', N'2', N'否', N'N', N'sys_yes_no', N'', N'danger', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'系统默认否')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'14', N'1', N'通知', N'1', N'sys_notice_type', N'', N'warning', N'Y', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'通知')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'15', N'2', N'公告', N'2', N'sys_notice_type', N'', N'success', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'公告')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'16', N'1', N'正常', N'0', N'sys_notice_status', N'', N'primary', N'Y', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'正常状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'17', N'2', N'关闭', N'1', N'sys_notice_status', N'', N'danger', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'关闭状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'18', N'99', N'其他', N'0', N'sys_oper_type', N'', N'info', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'其他操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'19', N'1', N'新增', N'1', N'sys_oper_type', N'', N'info', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'新增操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'20', N'2', N'修改', N'2', N'sys_oper_type', N'', N'info', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'修改操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'21', N'3', N'删除', N'3', N'sys_oper_type', N'', N'danger', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'删除操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'22', N'4', N'授权', N'4', N'sys_oper_type', N'', N'primary', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'授权操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'23', N'5', N'导出', N'5', N'sys_oper_type', N'', N'warning', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'导出操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'24', N'6', N'导入', N'6', N'sys_oper_type', N'', N'warning', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'导入操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'25', N'7', N'强退', N'7', N'sys_oper_type', N'', N'danger', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'强退操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'26', N'8', N'生成代码', N'8', N'sys_oper_type', N'', N'warning', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'生成操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'27', N'9', N'清空数据', N'9', N'sys_oper_type', N'', N'danger', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'清空操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'28', N'1', N'成功', N'0', N'sys_common_status', N'', N'primary', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'正常状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'29', N'2', N'失败', N'1', N'sys_common_status', N'', N'danger', N'N', N'0', N'admin', N'2025-11-03 11:44:45.533', N'', NULL, N'停用状态')
GO

SET IDENTITY_INSERT [dbo].[sys_dict_data] OFF
GO


-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dict_type]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dict_type]
GO

CREATE TABLE [dbo].[sys_dict_type] (
  [dict_id] bigint  IDENTITY(100,1) NOT NULL,
  [dict_name] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [dict_type] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [status] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [create_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [create_time] datetime  NULL,
  [update_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [update_time] datetime  NULL,
  [remark] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_dict_type] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_dict_type] ON
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'用户性别', N'sys_user_sex', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'用户性别列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'菜单状态', N'sys_show_hide', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'菜单状态列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'系统开关', N'sys_normal_disable', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'系统开关列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'任务状态', N'sys_job_status', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'任务状态列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'5', N'任务分组', N'sys_job_group', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'任务分组列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'6', N'系统是否', N'sys_yes_no', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'系统是否列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'7', N'通知类型', N'sys_notice_type', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'通知类型列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'8', N'通知状态', N'sys_notice_status', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'通知状态列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'9', N'操作类型', N'sys_oper_type', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'操作类型列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'10', N'系统状态', N'sys_common_status', N'0', N'admin', N'2025-11-03 11:43:20.003', N'', NULL, N'登录状态列表')
GO

SET IDENTITY_INSERT [dbo].[sys_dict_type] OFF
GO


-- ----------------------------
-- Table structure for sys_logininfor
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_logininfor]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_logininfor]
GO

CREATE TABLE [dbo].[sys_logininfor] (
  [info_id] bigint  IDENTITY(1,1) NOT NULL,
  [user_name] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [ipaddr] varchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [login_location] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [browser] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [os] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [status] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [msg] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [login_time] datetime  NULL
)
GO

ALTER TABLE [dbo].[sys_logininfor] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_logininfor
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_logininfor] ON
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'1', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 14', N'Windows 10', N'0', N'登录成功', N'2025-11-03 11:10:29.423')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'2', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 14', N'Windows 10', N'1', N'验证码错误', N'2025-11-03 11:15:47.127')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'3', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 14', N'Windows 10', N'0', N'登录成功', N'2025-11-03 11:15:53.060')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'4', N'admin', N'127.0.0.1', N'内网IP', N'Mobile Safari', N'Mac OS X (iPhone)', N'0', N'登录成功', N'2025-11-03 11:52:46.587')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'5', N'admin', N'127.0.0.1', N'内网IP', N'Mobile Safari', N'Mac OS X (iPhone)', N'0', N'登录成功', N'2025-11-03 13:42:02.847')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'6', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 14', N'Windows 10', N'0', N'登录成功', N'2025-11-03 14:32:14.897')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'7', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 14', N'Windows 10', N'0', N'登录成功', N'2025-11-03 14:34:10.493')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'8', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 14', N'Windows 10', N'0', N'登录成功', N'2025-11-03 14:38:17.347')
GO

SET IDENTITY_INSERT [dbo].[sys_logininfor] OFF
GO


-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_menu]
GO

CREATE TABLE [dbo].[sys_menu] (
  [menu_id] bigint  IDENTITY(1,1) NOT NULL,
  [menu_name] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [parent_id] bigint DEFAULT 0 NULL,
  [order_num] int DEFAULT 0 NULL,
  [path] varchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [component] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [query] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [route_name] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [is_frame] int DEFAULT 1 NULL,
  [is_cache] int DEFAULT 0 NULL,
  [menu_type] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [visible] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [status] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [perms] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [icon] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '#' NULL,
  [create_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [create_time] datetime2(7)  NULL,
  [update_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [update_time] datetime2(7)  NULL,
  [remark] varchar(500) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL
)
GO

ALTER TABLE [dbo].[sys_menu] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_menu
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_menu] ON
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'系统管理', N'0', N'1', N'system', NULL, N'', N'', N'1', N'0', N'M', N'0', N'0', N'', N'system', N'admin', N'2025-11-03 11:15:15.1166667', N'admin', N'2025-11-03 13:47:54.4033333', N'系统管理目录')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'系统监控', N'0', N'2', N'monitor', NULL, N'', N'', N'1', N'0', N'M', N'0', N'0', N'', N'monitor', N'admin', N'2025-11-03 11:15:15.1166667', N'admin', N'2025-11-03 14:32:52.6000000', N'系统监控目录')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'系统工具', N'0', N'3', N'tool', NULL, N'', N'', N'1', N'0', N'M', N'0', N'0', N'', N'tool', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'系统工具目录')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'若依官网', N'0', N'4', N'http://ruoyi.vip', NULL, N'', N'', N'0', N'0', N'M', N'1', N'1', N'', N'guide', N'admin', N'2025-11-03 11:15:15.1166667', N'admin', N'2025-11-03 13:48:04.1633333', N'若依官网地址')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'100', N'用户管理', N'1', N'1', N'user', N'system/user/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:user:list', N'user', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'用户管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'101', N'角色管理', N'1', N'2', N'role', N'system/role/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:role:list', N'peoples', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'角色管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'102', N'菜单管理', N'1', N'3', N'menu', N'system/menu/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:menu:list', N'tree-table', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'菜单管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'103', N'部门管理', N'1', N'4', N'dept', N'system/dept/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:dept:list', N'tree', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'部门管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'104', N'岗位管理', N'1', N'5', N'post', N'system/post/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:post:list', N'post', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'岗位管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'105', N'字典管理', N'1', N'6', N'dict', N'system/dict/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:dict:list', N'dict', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'字典管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'106', N'参数设置', N'1', N'7', N'config', N'system/config/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:config:list', N'edit', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'参数设置菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'107', N'通知公告', N'1', N'8', N'notice', N'system/notice/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:notice:list', N'message', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'通知公告菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'108', N'日志管理', N'1', N'9', N'log', N'', N'', N'', N'1', N'0', N'M', N'0', N'0', N'', N'log', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'日志管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'109', N'在线用户', N'2', N'1', N'online', N'monitor/online/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:online:list', N'online', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'在线用户菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'110', N'定时任务', N'2', N'2', N'job', N'monitor/job/index', N'', N'', N'1', N'0', N'C', N'1', N'1', N'monitor:job:list', N'job', N'admin', N'2025-11-03 11:15:15.1166667', N'admin', N'2025-11-03 14:41:28.5766667', N'定时任务菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'111', N'数据监控', N'2', N'3', N'druid', N'monitor/druid/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:druid:list', N'druid', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'数据监控菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'112', N'服务监控', N'2', N'4', N'server', N'monitor/server/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:server:list', N'server', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'服务监控菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'113', N'缓存监控', N'2', N'5', N'cache', N'monitor/cache/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:cache:list', N'redis', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'缓存监控菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'114', N'缓存列表', N'2', N'6', N'cacheList', N'monitor/cache/list', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:cache:list', N'redis-list', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'缓存列表菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'115', N'表单构建', N'3', N'1', N'build', N'tool/build/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'tool:build:list', N'build', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'表单构建菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'116', N'代码生成', N'3', N'2', N'gen', N'tool/gen/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'tool:gen:list', N'code', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'代码生成菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'117', N'系统接口', N'3', N'3', N'swagger', N'tool/swagger/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'tool:swagger:list', N'swagger', N'admin', N'2025-11-03 11:15:15.1166667', N'', NULL, N'系统接口菜单')
GO

SET IDENTITY_INSERT [dbo].[sys_menu] OFF
GO


-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_notice]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_notice]
GO

CREATE TABLE [dbo].[sys_notice] (
  [notice_id] int  IDENTITY(1,1) NOT NULL,
  [notice_title] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [notice_type] char(1) COLLATE Chinese_PRC_CI_AS  NULL,
  [notice_content] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [status] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [create_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [create_time] datetime  NULL,
  [update_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [update_time] datetime  NULL,
  [remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_notice] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_notice
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_notice] ON
GO

INSERT INTO [dbo].[sys_notice] ([notice_id], [notice_title], [notice_type], [notice_content], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'温馨提醒：2018-07-01 若依新版本发布啦', N'2', N'<p>新版本内容                    22</p>', N'0', N'admin', N'2025-11-03 10:46:43.130', N'admin', N'2025-11-03 11:46:38.737', N'管理员')
GO

INSERT INTO [dbo].[sys_notice] ([notice_id], [notice_title], [notice_type], [notice_content], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'维护通知：2018-07-01 若依系统凌晨维护', N'1', N'维护内容', N'0', N'admin', N'2025-11-03 10:46:43.130', N'', NULL, N'管理员')
GO

SET IDENTITY_INSERT [dbo].[sys_notice] OFF
GO


-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_oper_log]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_oper_log]
GO

CREATE TABLE [dbo].[sys_oper_log] (
  [oper_id] bigint  IDENTITY(100,1) NOT NULL,
  [title] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [business_type] int DEFAULT 0 NULL,
  [method] varchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [request_method] varchar(10) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [operator_type] int DEFAULT 0 NULL,
  [oper_name] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [dept_name] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [oper_url] varchar(255) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [oper_ip] varchar(128) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [oper_location] varchar(255) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [oper_param] varchar(2000) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [json_result] varchar(2000) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [status] int DEFAULT 0 NULL,
  [error_msg] varchar(2000) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [oper_time] datetime2(7)  NULL,
  [cost_time] bigint DEFAULT 0 NULL
)
GO

ALTER TABLE [dbo].[sys_oper_log] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'操作日志记录',
'SCHEMA', N'dbo',
'TABLE', N'sys_oper_log'
GO


-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_oper_log] ON
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'100', N'菜单管理', N'1', N'com.ruoyi.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"404","isCache":"0","isFrame":"1","menuName":"test","menuType":"M","orderNum":999,"params":{},"parentId":0,"path":"/test","status":"0","visible":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysMenuMapper.checkMenuNameUnique-Inline
### The error occurred while setting parameters
### SQL: SELECT   menu_id,   menu_name,   parent_id,   order_num,   path,   component,   [query],              route_name,   is_frame,   is_cache,   menu_type,   visible,   status,   ISNULL(perms, '''') AS perms,      icon,   create_time   FROM sys_menu      where menu_name=? and parent_id = ? limit 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
; uncategorized SQLException; SQL state [S0001]; error code [102]; “limit”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。', N'2025-11-03 11:24:56.8066667', N'61')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'101', N'菜单管理', N'1', N'com.ruoyi.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"404","isCache":"0","isFrame":"1","menuName":"test","menuType":"M","orderNum":999,"params":{},"parentId":0,"path":"/test","status":"0","visible":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysMenuMapper.checkMenuNameUnique-Inline
### The error occurred while setting parameters
### SQL: SELECT   menu_id,   menu_name,   parent_id,   order_num,   path,   component,   [query],              route_name,   is_frame,   is_cache,   menu_type,   visible,   status,   ISNULL(perms, '''') AS perms,      icon,   create_time   FROM sys_menu      where menu_name=? and parent_id = ? limit 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
; uncategorized SQLException; SQL state [S0001]; error code [102]; “limit”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。', N'2025-11-03 11:25:00.9500000', N'59')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'102', N'菜单管理', N'2', N'com.ruoyi.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2025-11-03 11:15:15","icon":"guide","isCache":"0","isFrame":"0","menuId":4,"menuName":"若依官网","menuType":"M","orderNum":4,"params":{},"parentId":0,"path":"http://ruoyi.vip","perms":"","query":"","routeName":"","status":"0","updateBy":"admin","visible":"1"}', NULL, N'1', N'
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “`”附近有语法错误。
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysMenuMapper.updateMenu-Inline
### The error occurred while setting parameters
### SQL: update sys_menu    SET menu_name = ?,    parent_id = ?,    order_num = ?,    path = ?,        `query` = ?,    route_name = ?,    is_frame = ?,    is_cache = ?,    menu_type = ?,    visible = ?,    status = ?,    perms = ?,    icon = ?,        update_by = ?,    update_time = getdate()    where menu_id = ?
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “`”附近有语法错误。
; uncategorized SQLException; SQL state [S0001]; error code [102]; “`”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “`”附近有语法错误。', N'2025-11-03 11:26:49.5233333', N'215')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'103', N'菜单管理', N'1', N'com.ruoyi.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createBy":"admin","icon":"button","isCache":"0","isFrame":"1","menuName":"test","menuType":"M","orderNum":1,"params":{},"parentId":0,"path":"/test","status":"0","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:27:22.7400000', N'121')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'104', N'菜单管理', N'2', N'com.ruoyi.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2025-11-03 11:27:22","icon":"button","isCache":"0","isFrame":"1","menuId":118,"menuName":"test11","menuType":"M","orderNum":1,"params":{},"parentId":0,"path":"/test","perms":"","routeName":"","status":"0","updateBy":"admin","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:27:56.8300000', N'191')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'105', N'部门管理', N'2', N'com.ruoyi.web.controller.system.SysDeptController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/dept', N'127.0.0.1', N'内网IP', N'{"ancestors":"0","children":[],"deptId":100,"deptName":"若依科技1","email":"ry@qq.com","leader":"若依","orderNum":0,"params":{},"parentId":0,"phone":"15888888888","status":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysDeptMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.phone, d.email, d.status, d.del_flag, d.create_by, d.create_time          from sys_dept d         where dept_name=? and parent_id = ? and del_flag = ''0'' limit 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
; uncategorized SQLException; SQL state [S0001]; error code [102]; “limit”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。', N'2025-11-03 11:28:08.9800000', N'87')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'106', N'部门管理', N'2', N'com.ruoyi.web.controller.system.SysDeptController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/dept', N'127.0.0.1', N'内网IP', N'{"ancestors":"0","children":[],"deptId":100,"deptName":"若依科技","email":"ry@qq.com","leader":"若依a","orderNum":0,"params":{},"parentId":0,"phone":"15888888888","status":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysDeptMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.phone, d.email, d.status, d.del_flag, d.create_by, d.create_time          from sys_dept d         where dept_name=? and parent_id = ? and del_flag = ''0'' limit 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
; uncategorized SQLException; SQL state [S0001]; error code [102]; “limit”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。', N'2025-11-03 11:28:41.6166667', N'58')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'107', N'菜单管理', N'3', N'com.ruoyi.web.controller.system.SysMenuController.remove()', N'DELETE', N'1', N'admin', N'研发部门', N'/system/menu/118', N'127.0.0.1', N'内网IP', N'118', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 ''sys_role_menu'' 无效。
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysRoleMenuMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select count(1) from sys_role_menu where menu_id = ?
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 ''sys_role_menu'' 无效。
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 ''sys_role_menu'' 无效。', N'2025-11-03 11:29:11.4166667', N'204')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'108', N'部门管理', N'2', N'com.ruoyi.web.controller.system.SysDeptController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/dept', N'127.0.0.1', N'内网IP', N'{"ancestors":"0","children":[],"deptId":100,"deptName":"若依科技","email":"ry@qq.com","leader":"若依a","orderNum":0,"params":{},"parentId":0,"phone":"15888888888","status":"0","updateBy":"admin"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:29:38.6166667', N'293')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'109', N'部门管理', N'2', N'com.ruoyi.web.controller.system.SysDeptController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/dept', N'127.0.0.1', N'内网IP', N'{"ancestors":"0","children":[],"deptId":100,"deptName":"若依科技a","email":"ry@qq.com","leader":"若依a","orderNum":0,"params":{},"parentId":0,"phone":"15888888888","status":"0","updateBy":"admin"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:29:44.3600000', N'237')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'110', N'岗位管理', N'1', N'com.ruoyi.web.controller.system.SysPostController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/post', N'127.0.0.1', N'内网IP', N'{"flag":false,"params":{},"postCode":"test1","postName":"test","postSort":0,"remark":"test1","status":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysPostMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysPostMapper.checkPostNameUnique-Inline
### The error occurred while setting parameters
### SQL: select post_id, post_code, post_name, post_sort, status, create_by, create_time, remark    from sys_post          where post_name=? limit 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
; uncategorized SQLException; SQL state [S0001]; error code [102]; “limit”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。', N'2025-11-03 11:30:12.2400000', N'58')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'111', N'菜单管理', N'3', N'com.ruoyi.web.controller.system.SysMenuController.remove()', N'DELETE', N'1', N'admin', N'研发部门', N'/system/menu/118', N'127.0.0.1', N'内网IP', N'118', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:31:29.6433333', N'173')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'112', N'用户管理', N'1', N'com.ruoyi.web.controller.system.SysUserController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"deptId":100,"email":"liukang3014@outlook.com","nickName":"test","params":{},"phonenumber":"13087693629","postIds":[1],"remark":"asdad","roleIds":[2],"sex":"0","status":"0","userName":"test1"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysUserMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysUserMapper.checkUserNameUnique-Inline
### The error occurred while setting parameters
### SQL: select user_id, user_name from sys_user where user_name = ? and del_flag = ''0'' limit 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。
; uncategorized SQLException; SQL state [S0001]; error code [102]; “limit”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “limit”附近有语法错误。', N'2025-11-03 11:32:29.6800000', N'114')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'113', N'用户管理', N'1', N'com.ruoyi.web.controller.system.SysUserController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"createBy":"admin","deptId":100,"email":"liukang3014@outlook.com","nickName":"test","params":{},"phonenumber":"13087693629","postIds":[1],"remark":"asdad","roleIds":[2],"sex":"0","status":"0","userId":3,"userName":"test1"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:39:36.2500000', N'622')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'114', N'用户管理', N'2', N'com.ruoyi.web.controller.system.SysUserController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"avatar":"","createBy":"admin","createTime":"2025-11-03 11:39:35","delFlag":"0","dept":{"ancestors":"0","children":[],"deptId":100,"deptName":"若依科技a","leader":"若依a","orderNum":0,"params":{},"parentId":0,"status":"0"},"deptId":100,"email":"liukang3014@outlook.com","loginIp":"","nickName":"test","params":{},"phonenumber":"13087693629","postIds":[1],"remark":"asdad","roleIds":[2],"roles":[{"admin":false,"dataScope":"2","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}],"sex":"0","status":"1","updateBy":"admin","userId":3,"userName":"test1"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:39:43.6166667', N'686')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'115', N'用户管理', N'3', N'com.ruoyi.web.controller.system.SysUserController.remove()', N'DELETE', N'1', N'admin', N'研发部门', N'/system/user/3', N'127.0.0.1', N'内网IP', N'[3]', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:39:47.6400000', N'367')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'116', N'字典类型', N'1', N'com.ruoyi.web.controller.system.SysDictTypeController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/type', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","dictName":"test","dictType":"test1","params":{},"remark":"test","status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:45:23.9233333', N'129')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'117', N'字典数据', N'1', N'com.ruoyi.web.controller.system.SysDictDataController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/data', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","cssClass":"333","default":false,"dictLabel":"111","dictSort":0,"dictType":"test1","dictValue":"222","listClass":"default","params":{},"remark":"444","status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:45:34.8566667', N'144')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'118', N'字典数据', N'2', N'com.ruoyi.web.controller.system.SysDictDataController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/dict/data', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","createTime":"2025-11-03 11:45:34","cssClass":"333","default":false,"dictCode":100,"dictLabel":"111","dictSort":0,"dictType":"test1","dictValue":"222111","isDefault":"N","listClass":"default","params":{},"remark":"444","status":"0","updateBy":"admin"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:45:38.7500000', N'127')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'119', N'字典类型', N'3', N'com.ruoyi.web.controller.system.SysDictDataController.remove()', N'DELETE', N'1', N'admin', N'研发部门', N'/system/dict/data/100', N'127.0.0.1', N'内网IP', N'[100]', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:45:40.9400000', N'191')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'120', N'字典类型', N'3', N'com.ruoyi.web.controller.system.SysDictTypeController.remove()', N'DELETE', N'1', N'admin', N'研发部门', N'/system/dict/type/100', N'127.0.0.1', N'内网IP', N'[100]', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:45:46.7500000', N'225')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'121', N'用户管理', N'2', N'com.ruoyi.web.controller.system.SysUserController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"avatar":"","createBy":"admin","createTime":"2025-11-03 10:31:54","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":105,"deptName":"测试部门","leader":"若依","orderNum":3,"params":{},"parentId":101,"status":"0"},"deptId":105,"email":"ry@qq.com","loginDate":"2025-11-03 10:31:54.653","loginIp":"127.0.0.1","nickName":"若依","params":{},"phonenumber":"15666666666","postIds":[2],"pwdUpdateDate":"2025-11-03 10:31:54.653","remark":"测试员","roleIds":[2],"roles":[{"admin":false,"dataScope":"2","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}],"sex":"0","status":"0","updateBy":"admin","userId":2,"userName":"ry"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:45:57.2833333', N'605')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'122', N'用户管理', N'2', N'com.ruoyi.web.controller.system.SysUserController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"avatar":"","createBy":"admin","createTime":"2025-11-03 10:31:54","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":105,"deptName":"测试部门","leader":"若依","orderNum":3,"params":{},"parentId":101,"status":"0"},"deptId":105,"email":"ry@qq.com","loginDate":"2025-11-03 10:31:54.653","loginIp":"127.0.0.1","nickName":"若依","params":{},"phonenumber":"15666666666","postIds":[2,3],"pwdUpdateDate":"2025-11-03 10:31:54.653","remark":"测试员","roleIds":[2],"roles":[{"admin":false,"dataScope":"2","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}],"sex":"0","status":"0","updateBy":"admin","userId":2,"userName":"ry"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:46:04.9766667', N'594')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'123', N'岗位管理', N'2', N'com.ruoyi.web.controller.system.SysPostController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/post', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","createTime":"2025-11-03 10:31:54","flag":false,"params":{},"postCode":"user","postId":4,"postName":"普通员工1","postSort":4,"remark":"","status":"0","updateBy":"admin"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:46:13.4166667', N'193')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'124', N'角色管理', N'2', N'com.ruoyi.web.controller.system.SysRoleController.dataScope()', N'PUT', N'1', N'admin', N'研发部门', N'/system/role/dataScope', N'127.0.0.1', N'内网IP', N'{"admin":false,"createTime":"2025-11-03 10:34:00","dataScope":"2","delFlag":"0","deptCheckStrictly":true,"deptIds":[100,101,103,105],"flag":false,"menuCheckStrictly":true,"params":{},"remark":"普通角色","roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:46:25.9133333', N'421')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'125', N'角色管理', N'2', N'com.ruoyi.web.controller.system.SysRoleController.dataScope()', N'PUT', N'1', N'admin', N'研发部门', N'/system/role/dataScope', N'127.0.0.1', N'内网IP', N'{"admin":false,"createTime":"2025-11-03 10:34:00","dataScope":"2","delFlag":"0","deptCheckStrictly":true,"deptIds":[100,101,105],"flag":false,"menuCheckStrictly":true,"params":{},"remark":"普通角色","roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:46:29.8900000', N'334')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'126', N'通知公告', N'2', N'com.ruoyi.web.controller.system.SysNoticeController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/notice', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","createTime":"2025-11-03 10:46:43","noticeContent":"<p>新版本内容                    22</p>","noticeId":1,"noticeTitle":"温馨提醒：2018-07-01 若依新版本发布啦","noticeType":"2","params":{},"remark":"管理员","status":"0","updateBy":"admin"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:46:38.8133333', N'70')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'127', N'个人信息', N'2', N'com.ruoyi.web.controller.system.SysProfileController.updateProfile()', N'PUT', N'1', N'admin', N'研发部门', N'/system/user/profile', N'127.0.0.1', N'内网IP', N'{"admin":true,"createBy":"admin","createTime":"2025-11-03 10:31:54","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":103,"deptName":"研发部门","leader":"若依","orderNum":1,"params":{"@type":"java.util.HashMap"},"parentId":101,"status":"0"},"deptId":103,"email":"ry@163.com2","loginDate":"2025-11-03 11:15:49.03","loginIp":"127.0.0.1","nickName":"若依1","params":{"@type":"java.util.HashMap"},"phonenumber":"15888888887","pwdUpdateDate":"2025-11-03 10:31:54.653","remark":"管理员","roles":[{"admin":true,"dataScope":"1","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{"@type":"java.util.HashMap"},"roleId":1,"roleKey":"admin","roleName":"超级管理员","roleSort":1,"status":"0"}],"sex":"1","status":"0","userId":1,"userName":"admin"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 11:53:10.2800000', N'208')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'128', N'菜单管理', N'3', N'com.ruoyi.web.controller.system.SysMenuController.remove()', N'DELETE', N'1', N'admin', N'研发部门', N'/system/menu/4', N'127.0.0.1', N'内网IP', N'4', N'{"msg":"菜单已分配,不允许删除","code":601}', N'0', NULL, N'2025-11-03 13:42:29.9633333', N'129')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'129', N'菜单管理', N'2', N'com.ruoyi.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2025-11-03 11:15:15","icon":"guide","isCache":"0","isFrame":"0","menuId":4,"menuName":"若依官网","menuType":"M","orderNum":4,"params":{},"parentId":0,"path":"http://ruoyi.vip","perms":"","query":"","routeName":"","status":"1","updateBy":"admin","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_menu
		 SET menu_name = ?,
			parent_id = ?,
			order_num = ?,
			path = ?,
			
			[query] = ?,      
			route_name = ?,
			is_frame = ?,
			is_cache = ?,
			menu_type = ?,
			visible = ?,
			status = ?,
			perms = ?,
			icon = ?,
			
			update_by = ?,
			update_time = GETDATE() 
		WHERE menu_id = ?
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysMenuMapper.updateMenu
### The error occurred while executing an update
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_menu
		 SET menu_name = ?,
			parent_id = ?,
			order_num = ?,
			path = ?,
			
			[query] = ?,      
			route_name = ?,
			is_frame = ?,
			is_cache = ?,
			menu_type = ?,
			visible = ?,
			status = ?,
			perms = ?,
			icon = ?,
			
			update_by = ?,
			update_time = GETDATE() 
		WHERE menu_id = ?', N'2025-11-03 13:42:36.4600000', N'84')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'130', N'菜单管理', N'2', N'com.ruoyi.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2025-11-03 11:15:15","icon":"guide","isCache":"0","isFrame":"1","menuId":4,"menuName":"若依官网","menuType":"M","orderNum":4,"params":{},"parentId":0,"path":"http://ruoyi.vip","perms":"","query":"","routeName":"","status":"0","updateBy":"admin","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_menu
		 SET menu_name = ?,
			parent_id = ?,
			order_num = ?,
			path = ?,
			
			[query] = ?,      
			route_name = ?,
			is_frame = ?,
			is_cache = ?,
			menu_type = ?,
			visible = ?,
			status = ?,
			perms = ?,
			icon = ?,
			
			update_by = ?,
			update_time = GETDATE() 
		WHERE menu_id = ?
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysMenuMapper.updateMenu
### The error occurred while executing an update
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_menu
		 SET menu_name = ?,
			parent_id = ?,
			order_num = ?,
			path = ?,
			
			[query] = ?,      
			route_name = ?,
			is_frame = ?,
			is_cache = ?,
			menu_type = ?,
			visible = ?,
			status = ?,
			perms = ?,
			icon = ?,
			
			update_by = ?,
			update_time = GETDATE() 
		WHERE menu_id = ?', N'2025-11-03 13:42:46.8166667', N'59')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'131', N'菜单管理', N'2', N'com.ruoyi.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2025-11-03 11:15:15","icon":"guide","isCache":"0","isFrame":"0","menuId":4,"menuName":"若依官网","menuType":"M","orderNum":4,"params":{},"parentId":0,"path":"http://ruoyi.vip","perms":"","query":"","routeName":"","status":"0","updateBy":"admin","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_menu
		 SET menu_name = ?,
			parent_id = ?,
			order_num = ?,
			path = ?,
			
			[query] = ?,      
			route_name = ?,
			is_frame = ?,
			is_cache = ?,
			menu_type = ?,
			visible = ?,
			status = ?,
			perms = ?,
			icon = ?,
			
			update_by = ?,
			update_time = GETDATE() 
		WHERE menu_id = ?
### The error may exist in file [D:\workFile\my\code\weighing-server\weighing\ruoyi-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysMenuMapper.updateMenu
### The error occurred while executing an update
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_menu
		 SET menu_name = ?,
			parent_id = ?,
			order_num = ?,
			path = ?,
			
			[query] = ?,      
			route_name = ?,
			is_frame = ?,
			is_cache = ?,
			menu_type = ?,
			visible = ?,
			status = ?,
			perms = ?,
			icon = ?,
			
			update_by = ?,
			update_time = GETDATE() 
		WHERE menu_id = ?', N'2025-11-03 13:45:13.6500000', N'63')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'132', N'菜单管理', N'2', N'com.ruoyi.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2025-11-03 11:15:15","icon":"system","isCache":"0","isFrame":"1","menuId":1,"menuName":"系统管理","menuType":"M","orderNum":1,"params":{},"parentId":0,"path":"system","perms":"","query":"","routeName":"","status":"0","updateBy":"admin","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 13:47:54.4933333', N'181')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'133', N'菜单管理', N'2', N'com.ruoyi.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2025-11-03 11:15:15","icon":"guide","isCache":"0","isFrame":"0","menuId":4,"menuName":"若依官网","menuType":"M","orderNum":4,"params":{},"parentId":0,"path":"http://ruoyi.vip","perms":"","query":"","routeName":"","status":"1","updateBy":"admin","visible":"1"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 13:48:04.2300000', N'160')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'134', N'用户管理', N'2', N'com.weighing.web.controller.system.SysUserController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"avatar":"","createBy":"admin","createTime":"2025-11-03 10:31:54","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":105,"deptName":"测试部门","leader":"若依","orderNum":3,"params":{},"parentId":101,"status":"0"},"deptId":105,"email":"ry@qq.com","loginDate":"2025-11-03 10:31:54.653","loginIp":"127.0.0.1","nickName":"若依","params":{},"phonenumber":"15666666666","postIds":[2,3],"pwdUpdateDate":"2025-11-03 10:31:54.653","remark":"测试员","roleIds":[2],"roles":[{"admin":false,"dataScope":"2","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}],"sex":"1","status":"0","updateBy":"admin","userId":2,"userName":"ry"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 14:32:29.7033333', N'709')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'135', N'菜单管理', N'2', N'com.weighing.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2025-11-03 11:15:15","icon":"monitor","isCache":"0","isFrame":"1","menuId":2,"menuName":"系统监控1","menuType":"M","orderNum":2,"params":{},"parentId":0,"path":"monitor","perms":"","query":"","routeName":"","status":"0","updateBy":"admin","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 14:32:47.8900000', N'187')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'136', N'菜单管理', N'2', N'com.weighing.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2025-11-03 11:15:15","icon":"monitor","isCache":"0","isFrame":"1","menuId":2,"menuName":"系统监控","menuType":"M","orderNum":2,"params":{},"parentId":0,"path":"monitor","perms":"","query":"","routeName":"","status":"0","updateBy":"admin","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 14:32:52.6666667', N'114')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'137', N'菜单管理', N'2', N'com.weighing.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"component":"monitor/job/index","createTime":"2025-11-03 11:15:15","icon":"job","isCache":"0","isFrame":"1","menuId":110,"menuName":"定时任务","menuType":"C","orderNum":2,"params":{},"parentId":2,"path":"job","perms":"monitor:job:list","query":"","routeName":"","status":"1","updateBy":"admin","visible":"1"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2025-11-03 14:41:28.6566667', N'405')
GO

SET IDENTITY_INSERT [dbo].[sys_oper_log] OFF
GO


-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_post]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_post]
GO

CREATE TABLE [dbo].[sys_post] (
  [post_id] bigint  IDENTITY(1,1) NOT NULL,
  [post_code] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [post_name] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [post_sort] int DEFAULT 0 NOT NULL,
  [status] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [create_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [create_time] datetime  NULL,
  [update_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [update_time] datetime  NULL,
  [remark] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_post] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_post
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_post] ON
GO

INSERT INTO [dbo].[sys_post] ([post_id], [post_code], [post_name], [post_sort], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'ceo', N'董事长', N'1', N'0', N'admin', N'2025-11-03 10:31:54.820', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_post] ([post_id], [post_code], [post_name], [post_sort], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'se', N'项目经理', N'2', N'0', N'admin', N'2025-11-03 10:31:54.820', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_post] ([post_id], [post_code], [post_name], [post_sort], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'hr', N'人力资源', N'3', N'0', N'admin', N'2025-11-03 10:31:54.820', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_post] ([post_id], [post_code], [post_name], [post_sort], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'user', N'普通员工1', N'4', N'0', N'admin', N'2025-11-03 10:31:54.820', N'admin', N'2025-11-03 11:46:13.347', N'')
GO

SET IDENTITY_INSERT [dbo].[sys_post] OFF
GO


-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role]
GO

CREATE TABLE [dbo].[sys_role] (
  [role_id] bigint  IDENTITY(1,1) NOT NULL,
  [role_name] varchar(30) COLLATE Chinese_PRC_CI_AS  NULL,
  [role_key] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [role_sort] int DEFAULT 0 NULL,
  [data_scope] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '1' NULL,
  [menu_check_strictly] bit DEFAULT 1 NULL,
  [dept_check_strictly] bit DEFAULT 1 NULL,
  [status] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [del_flag] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [create_by] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime DEFAULT getdate() NULL,
  [update_by] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [update_time] datetime  NULL,
  [remark] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_role] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_role
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_role] ON
GO

INSERT INTO [dbo].[sys_role] ([role_id], [role_name], [role_key], [role_sort], [data_scope], [menu_check_strictly], [dept_check_strictly], [status], [del_flag], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'超级管理员', N'admin', N'1', N'1', N'1', N'1', N'0', N'0', N'admin', N'2025-11-03 10:34:00.053', NULL, NULL, N'超级管理员')
GO

INSERT INTO [dbo].[sys_role] ([role_id], [role_name], [role_key], [role_sort], [data_scope], [menu_check_strictly], [dept_check_strictly], [status], [del_flag], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'普通角色', N'common', N'2', N'2', N'1', N'1', N'0', N'0', N'admin', N'2025-11-03 10:34:00.053', NULL, N'2025-11-03 11:46:29.600', N'普通角色')
GO

SET IDENTITY_INSERT [dbo].[sys_role] OFF
GO


-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role_dept]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role_dept]
GO

CREATE TABLE [dbo].[sys_role_dept] (
  [role_id] bigint  NOT NULL,
  [dept_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_role_dept] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
INSERT INTO [dbo].[sys_role_dept] ([role_id], [dept_id]) VALUES (N'2', N'100')
GO

INSERT INTO [dbo].[sys_role_dept] ([role_id], [dept_id]) VALUES (N'2', N'101')
GO

INSERT INTO [dbo].[sys_role_dept] ([role_id], [dept_id]) VALUES (N'2', N'105')
GO


-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role_menu]
GO

CREATE TABLE [dbo].[sys_role_menu] (
  [role_id] bigint  NOT NULL,
  [menu_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_role_menu] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'2')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'3')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'4')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'100')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'101')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'102')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'103')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'104')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'105')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'106')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'107')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'108')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'109')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'110')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'111')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'112')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'113')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'114')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'115')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'116')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'117')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'500')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'501')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1000')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1001')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1002')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1003')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1004')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1005')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1006')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1007')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1008')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1009')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1010')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1011')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1012')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1013')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1014')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1015')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1016')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1017')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1018')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1019')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1020')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1021')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1022')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1023')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1024')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1025')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1026')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1027')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1028')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1029')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1030')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1031')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1032')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1033')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1034')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1035')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1036')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1037')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1038')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1039')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1040')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1041')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1042')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1043')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1044')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1045')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1046')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1047')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1048')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1049')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1050')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1051')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1052')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1053')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1054')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1055')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1056')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1057')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1058')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1059')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1060')
GO


-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user]
GO

CREATE TABLE [dbo].[sys_user] (
  [user_id] bigint  IDENTITY(1,1) NOT NULL,
  [dept_id] bigint  NULL,
  [user_name] varchar(30) COLLATE Chinese_PRC_CI_AS  NULL,
  [nick_name] varchar(30) COLLATE Chinese_PRC_CI_AS  NULL,
  [user_type] varchar(2) COLLATE Chinese_PRC_CI_AS DEFAULT '00' NULL,
  [email] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [phonenumber] varchar(11) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [sex] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [avatar] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [password] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [status] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [del_flag] char(1) COLLATE Chinese_PRC_CI_AS DEFAULT '0' NULL,
  [login_ip] varchar(128) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [login_date] datetime  NULL,
  [pwd_update_date] datetime  NULL,
  [create_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [create_time] datetime  NULL,
  [update_by] varchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [update_time] datetime  NULL,
  [remark] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_user] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_user
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_user] ON
GO

INSERT INTO [dbo].[sys_user] ([user_id], [dept_id], [user_name], [nick_name], [user_type], [email], [phonenumber], [sex], [avatar], [password], [status], [del_flag], [login_ip], [login_date], [pwd_update_date], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'103', N'admin', N'陈中', N'00', N'chenzhon@163.com', N'13773180180', N'1', N'', N'$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', N'0', N'0', N'127.0.0.1', N'2025-11-03 14:38:16.337', N'2025-11-03 10:31:54.653', N'admin', N'2025-11-03 10:31:54.653', N'', N'2025-11-03 11:53:10.183', N'管理员')
GO

INSERT INTO [dbo].[sys_user] ([user_id], [dept_id], [user_name], [nick_name], [user_type], [email], [phonenumber], [sex], [avatar], [password], [status], [del_flag], [login_ip], [login_date], [pwd_update_date], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'105', N'test', N'testAdmin', N'00', N'test@qq.com', N'15666666666', N'1', N'', N'$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', N'0', N'0', N'127.0.0.1', N'2025-11-03 10:31:54.653', N'2025-11-03 10:31:54.653', N'admin', N'2025-11-03 10:31:54.653', N'admin', N'2025-11-03 14:32:29.517', N'测试员')
GO

INSERT INTO [dbo].[sys_user] ([user_id], [dept_id], [user_name], [nick_name], [user_type], [email], [phonenumber], [sex], [avatar], [password], [status], [del_flag], [login_ip], [login_date], [pwd_update_date], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'100', N'test1', N'test', N'00', N'liukang3014@outlook.com', N'13087693629', N'0', N'', N'$2a$10$A0EnlGxPzN5gHSAUBKngrOfUxpTBawpHNf7QTMQbFWDNrH7PnALa6', N'1', N'2', N'', NULL, NULL, N'admin', N'2025-11-03 11:39:35.950', N'admin', N'2025-11-03 11:39:43.433', N'asdad')
GO

SET IDENTITY_INSERT [dbo].[sys_user] OFF
GO


-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user_post]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user_post]
GO

CREATE TABLE [dbo].[sys_user_post] (
  [user_id] bigint  NOT NULL,
  [post_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_user_post] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
INSERT INTO [dbo].[sys_user_post] ([user_id], [post_id]) VALUES (N'1', N'1')
GO

INSERT INTO [dbo].[sys_user_post] ([user_id], [post_id]) VALUES (N'2', N'2')
GO

INSERT INTO [dbo].[sys_user_post] ([user_id], [post_id]) VALUES (N'2', N'3')
GO


-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user_role]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user_role]
GO

CREATE TABLE [dbo].[sys_user_role] (
  [user_id] bigint  NOT NULL,
  [role_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_user_role] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO [dbo].[sys_user_role] ([user_id], [role_id]) VALUES (N'1', N'1')
GO

INSERT INTO [dbo].[sys_user_role] ([user_id], [role_id]) VALUES (N'2', N'2')
GO


-- ----------------------------
-- Primary Key structure for table comMaterialGroup
-- ----------------------------
ALTER TABLE [dbo].[comMaterialGroup] ADD CONSTRAINT [PK__comMater__C50610F72895B3D5] PRIMARY KEY CLUSTERED ([MaterialId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table CU_CUZLLSub
-- ----------------------------
ALTER TABLE [dbo].[CU_CUZLLSub] ADD CONSTRAINT [PK_CU_CUZLLSub] PRIMARY KEY CLUSTERED ([BillNo], [RowCode])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table CU_CZLLMain
-- ----------------------------
ALTER TABLE [dbo].[CU_CZLLMain] ADD CONSTRAINT [PK_CU_CZLLMain] PRIMARY KEY CLUSTERED ([BillNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table ppProduceOrder
-- ----------------------------
ALTER TABLE [dbo].[ppProduceOrder] ADD CONSTRAINT [PK__ppProduc__11F2841903111386] PRIMARY KEY CLUSTERED ([BillNo])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for ppSubMaterialInfo
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[ppSubMaterialInfo]', RESEED, 37)
GO


-- ----------------------------
-- Primary Key structure for table ppSubMaterialInfo
-- ----------------------------
ALTER TABLE [dbo].[ppSubMaterialInfo] ADD CONSTRAINT [PK__ppSubMat__3214EC072A5A90C6] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_config
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_config]', RESEED, 8)
GO


-- ----------------------------
-- Primary Key structure for table sys_config
-- ----------------------------
ALTER TABLE [dbo].[sys_config] ADD CONSTRAINT [PK__sys_conf__4AD1BFF17E7AB833] PRIMARY KEY CLUSTERED ([config_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_dept
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_dept]', RESEED, 109)
GO


-- ----------------------------
-- Primary Key structure for table sys_dept
-- ----------------------------
ALTER TABLE [dbo].[sys_dept] ADD CONSTRAINT [PK__sys_dept__DCA659744DEDBB23] PRIMARY KEY CLUSTERED ([dept_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_dict_data
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_dict_data]', RESEED, 100)
GO


-- ----------------------------
-- Primary Key structure for table sys_dict_data
-- ----------------------------
ALTER TABLE [dbo].[sys_dict_data] ADD CONSTRAINT [PK__sys_dict__19CBC34B4FFB53AD] PRIMARY KEY CLUSTERED ([dict_code])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_dict_type
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_dict_type]', RESEED, 100)
GO


-- ----------------------------
-- Uniques structure for table sys_dict_type
-- ----------------------------
ALTER TABLE [dbo].[sys_dict_type] ADD CONSTRAINT [UQ__sys_dict__75FC1B93C145CE0F] UNIQUE NONCLUSTERED ([dict_type] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_dict_type
-- ----------------------------
ALTER TABLE [dbo].[sys_dict_type] ADD CONSTRAINT [PK__sys_dict__3BD4186CC99D9A7F] PRIMARY KEY CLUSTERED ([dict_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_logininfor
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_logininfor]', RESEED, 8)
GO


-- ----------------------------
-- Primary Key structure for table sys_logininfor
-- ----------------------------
ALTER TABLE [dbo].[sys_logininfor] ADD CONSTRAINT [PK__sys_logi__3D8A9C1A8D561D87] PRIMARY KEY CLUSTERED ([info_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_menu
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_menu]', RESEED, 118)
GO


-- ----------------------------
-- Primary Key structure for table sys_menu
-- ----------------------------
ALTER TABLE [dbo].[sys_menu] ADD CONSTRAINT [PK__sys_menu__4CA0FADC0E7D403D] PRIMARY KEY CLUSTERED ([menu_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_notice
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_notice]', RESEED, 2)
GO


-- ----------------------------
-- Primary Key structure for table sys_notice
-- ----------------------------
ALTER TABLE [dbo].[sys_notice] ADD CONSTRAINT [PK_sys_notice] PRIMARY KEY CLUSTERED ([notice_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_oper_log
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_oper_log]', RESEED, 137)
GO


-- ----------------------------
-- Indexes structure for table sys_oper_log
-- ----------------------------
CREATE NONCLUSTERED INDEX [idx_sys_oper_log_bt]
ON [dbo].[sys_oper_log] (
  [business_type] ASC
)
GO

CREATE NONCLUSTERED INDEX [idx_sys_oper_log_s]
ON [dbo].[sys_oper_log] (
  [status] ASC
)
GO

CREATE NONCLUSTERED INDEX [idx_sys_oper_log_ot]
ON [dbo].[sys_oper_log] (
  [oper_time] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_oper_log
-- ----------------------------
ALTER TABLE [dbo].[sys_oper_log] ADD CONSTRAINT [PK__sys_oper__34723BF9FBAEF6ED] PRIMARY KEY CLUSTERED ([oper_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_post
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_post]', RESEED, 4)
GO


-- ----------------------------
-- Primary Key structure for table sys_post
-- ----------------------------
ALTER TABLE [dbo].[sys_post] ADD CONSTRAINT [PK__sys_post__3ED78766F0FDEADC] PRIMARY KEY CLUSTERED ([post_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_role
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_role]', RESEED, 2)
GO


-- ----------------------------
-- Primary Key structure for table sys_role
-- ----------------------------
ALTER TABLE [dbo].[sys_role] ADD CONSTRAINT [PK__sys_role__760965CC43899A59] PRIMARY KEY CLUSTERED ([role_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_role_dept
-- ----------------------------
ALTER TABLE [dbo].[sys_role_dept] ADD CONSTRAINT [PK_sys_role_dept] PRIMARY KEY CLUSTERED ([role_id], [dept_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_role_menu
-- ----------------------------
ALTER TABLE [dbo].[sys_role_menu] ADD CONSTRAINT [PK_sys_role_menu] PRIMARY KEY CLUSTERED ([role_id], [menu_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_user
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_user]', RESEED, 3)
GO


-- ----------------------------
-- Primary Key structure for table sys_user
-- ----------------------------
ALTER TABLE [dbo].[sys_user] ADD CONSTRAINT [PK__sys_user__B9BE370F50BC99F0] PRIMARY KEY CLUSTERED ([user_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_user_post
-- ----------------------------
ALTER TABLE [dbo].[sys_user_post] ADD CONSTRAINT [PK_sys_user_post] PRIMARY KEY CLUSTERED ([user_id], [post_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_user_role
-- ----------------------------
ALTER TABLE [dbo].[sys_user_role] ADD CONSTRAINT [PK__sys_user__6EDEA153C44AC1E5] PRIMARY KEY CLUSTERED ([user_id], [role_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Foreign Keys structure for table ppSubMaterialInfo
-- ----------------------------
ALTER TABLE [dbo].[ppSubMaterialInfo] ADD CONSTRAINT [FK_ppSubMaterialInfo_ppProduceOrder] FOREIGN KEY ([BillNo]) REFERENCES [dbo].[ppProduceOrder] ([BillNo]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

